计算机与现代化 ›› 2013, Vol. 1 ›› Issue (4): 57-59.doi: 10.3969/j.issn.1006-2475.2013.04.014
• 软件工程 • 上一篇 下一篇
褚龙现
收稿日期:
修回日期:
出版日期:
发布日期:
CHU Long-xian
Received:
Revised:
Online:
Published:
摘要： 对数据进行频繁的更新操作可能破坏数据库的完整性，合理设计触发器可以有效保护数据。本文讨论在SQL Server 2005中通过DML触发器技术实现数据的完整性控制机制，重点论述DML触发器工作原理和实现过程，并结合实例分析设计触发器的基本步骤。测试结果表明，触发器的应用可提高系统性能，很好地维护数据库的完整性。
关键词: 数据库, 完整性, 触发器, SQL Server
Abstract: Frequently updating data may undermine the integrity of database, and trigger properly designed can protect data effectively. The paper discusses the basic steps of data integrity control mechanism according to DML trigger technology in SQL Server 2005. It focuses on DML trigger work principle and implementation process with examples of triggers design. The test results show that the application of trigger improves the system performance and maintains the integrity of database.
Key words: database, integrity, trigger, SQL Server
中图分类号:
TP311
褚龙现. DML触发器保持数据库完整性应用研究[J]. 计算机与现代化, 2013, 1(4): 57-59.
CHU Long-xian. Application Research on DML Triggers in Maintaining Database Integrity[J]. Computer and Modernization, 2013, 1(4): 57-59.
0 / / 推荐
导出引用管理器 EndNote|Ris|BibTeX
链接本文: http://www.c-a-m.org.cn/CN/10.3969/j.issn.1006-2475.2013.04.014
http://www.c-a-m.org.cn/CN/Y2013/V1/I4/57
